﻿SELECT TOP 1
[Medlemsnr] as [Medlemsnummer] 
,[Efternamn] 
,[Förnamn] 
,[Adress] AS [Gatuadress] 
,Replace([Postnr],' ','') AS [Postnummer_(XXXXX)] 
,[Postadress] AS [Postort] 
,[Telefonnr] AS [Hemtelefon_(+46XXXXXX)] 
,[Telefonnr2] AS [Mobil_(+46XXXXXX)] 
,[Personnummer] AS [Personnummer_(ÅÅÅÅMMDD-XXXX)] 
,[Email] AS [Epost] ,[IntradesDatum] AS [Medlem sedan] 
,CASE [Kön] WHEN 'K' THEN 'Kvinna' ELSE 'Man' END AS [Kön_(Man/Kvinna)] 
,[N3SportID] AS [IdrottsID] 
,'Sverige' AS [Land]
FROM [MEDLEM] 
WHERE BETALT = 1